﻿<cfscript>
DB = 'chinalaohu';
</cfscript>

<cfparam name="respMsg" default="">
<cfparam name="SYSRESERVED" default="">


<cfquery datasource="#DB#">
insert into tmp(post,act,dt)
value('#serializeJSON(FORM)#','UPMP',#now()#)
</cfquery>


<cfquery datasource="#DB#">
insert into UPMP_back(dt,version,charset,signMethod,signature,transType,merId,transStatus,respCode,respMsg,qn,orderTime,orderNumber,settleDate,settleAmount,settleCurrency,exchangeRate,SYSRESERVED)
value(#now()#,'#version#','#charset#','#signMethod#','#signature#','#transType#',
'#merId#','#transStatus#','#respCode#','#respMsg#',
'#qn#','#orderTime#','#orderNumber#','#settleDate#','#settleAmount#','#settleCurrency#','#exchangeRate#','#SYSRESERVED#')
</cfquery>




<!---
<cfquery datasource="#DB#">
insert into tmp(post,act,dt)
value('#serializeJSON(FORM)#','UPMP',#now()#)
</cfquery>
<cftry>

<cfquery datasource="#DB#">
insert into UPMP_back(dt,version,charset,signMethod,signature,transType,merId,transStatus,respMsg,qn,orderNumber,settleAmount,settleCurrency,sysReserved)
value(#now()#,'#version#','#charset#','#signMethod#','#signature#','#transType#','#merId#','#transStatus#','#respMsg#','#qn#','#orderNumber#','#settleAmount#','#settleCurrency#','#sysReserved#')
</cfquery>

<cfcatch type="any">

<cfquery datasource="#DB#">
insert into tmp(post,act,dt)
value('#serializeJSON(cfcatch)#','UPMP',#now()#)
</cfquery>

</cfcatch>

</cftry>--->